Power Programmierung/Power-Programmierung (Tewi)(1994).iso/magazine/dbms_mag/9103/sql4.mar

Text File | 1991-01-22 | 420b | 2 lines

CREATE VIEW whole_db (c#,name,city,                      i#,date,qty,                      p#,pname,color,wt,price) AS  SELECT customer.c#,customer.name,customer.city,         invoice.i#,invoice.date,         litem.qty,         part.p#,part.pname,part.color,part.wt,part.price    FROM customer, invoice, litem, part   WHERE customer.c# = invoice.c#     AND invoice.i# = litem.i#     AND part.p# = litem.p#;